[dbo].[BAECartEventGetAllForUser]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAECartEventGetAllForUser
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@Id
varchar(32)
32
SQL Script
create
procedure
[dbo]
.
[BAECartEventGetAllForUser]
@Id
varchar
(
32
)
as
SELECT
*
FROM
CartEvent
ce
INNER
JOIN
CartItem
ci
on
ci.CartItemID
=
ce.CartItemID
WHERE
ci.UserID
=
@Id
ORDER
BY
ce.Title
GO
Uses
[dbo].[CartEvent]
[dbo].[CartItem]
dbo